WLE7002E25 need to separate phy firmware. 

https://github.com/quic/upstream-wifi-fw/tree/main/ath12k-firmware/QCN9274/hw2.0/1.3.1/WLAN.WBE.1.3.1-00130-QCAHKSWPL_SILICONZ-1

The official firmware It can be downloaded from the following link https://git.codelinaro.org/clo/ath-firmware/ath12k-firmware/-/blob/main/QCN9274/hw2.0/testing/1.1.1/WLAN.WBE.1.1.1-00210-QCAHKSWPL_SILICONZ-1/firmware-2.bin?ref_type=heads
Put the firmware into /lib/firmware/ath12k/QCN9274/hw2.0/

But split phy and firmware-2.bin does not support linux kernel 6.8. You need to download backportfrom https://mirror2.openwrt.org/sources/backports-6.9.1.tar.xz.
Install software to build backports with "sudo apt install build-essential flex bison ncurses-dev".
The command need to prepare the backport
tar -xf backports-6.9.1.tar.xz
Patch the attached patch files. This will enable support linux kernel 6.xx and add defconfig-ath12k
cd backports-6.9.1/
patch -p1 < [patch file location]
The command need to compile and install backport
make defconfig-ath12k
make
sudo make INSTALL_MOD_STRIP=1 install

---------------

We have tested this and it works. you can use the link provided directly.

See if it works on your end.

split phy and firmware-2.bin does not support linux kernel 6.8. Need to download backport from https://mirror2.openwrt.org/sources/backports-6.9.1.tar.xz.
Install software to build backports with "sudo apt install build-essential flex bison ncurses-dev".
The command need to prepare the backport
tar -xf backports-6.9.1.tar.xz
Patch the attached patch files. This will enable support linux kernel 6.xx and add defconfig-ath12k
cd backports-6.9.1/
patch -p1 < [patch file location]
The command need to compile and install backport
make defconfig-ath12k
make
sudo make INSTALL_MOD_STRIP=1 install